USE [Leetcode]
create table Ru
(
	Id int primary key not null identity,
	Email varchar(80)not null 
)
go
insert into Ru(Email) values ('a@b.com'),('c@d,com'),('a@b.com')
select Email from Ru
group by Email
having count (Email)>1